USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0005_DROP_TABLAS2]    Script Date: 11/28/2011 12:02:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_M0005_DROP_TABLAS2]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_M0005_DROP_TABLAS2]
GO

USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0005_DROP_TABLAS2]    Script Date: 11/28/2011 12:02:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		JJ
-- Create date: 28/11/2011
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[WASP_M0005_DROP_TABLAS2] --en dts es el segundo drop tablas, es el job 11.0 drop tablas
AS
BEGIN
if exists (select * from dbo.sysobjects
					where id = object_id(N'[dbo].[base]')
					and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
drop table [dbo].[base]
end

if exists (select * from dbo.sysobjects
					where id = object_id(N'[dbo].[capital]')
					and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
drop table [dbo].[capital]
end

END

GO

